Desktop Computer Skills
Microsoft Office 2013: Beginning Access
Access 2013 (Windows): Understanding Tables, Fields, & Entries
ds_msac2013_03_enus
Access 2013: Creating Forms & Queries
ds_msac2013_06_enus
Access 2013: Finding & Organizing Data
ds_msac2013_05_enus
Access 2013: Inserting, Importing, & Formatting Data
ds_msac2013_04_enus
Access 2013: Report & Analysis Tools
ds_msac2013_07_enus
Access 2013: Saving, Printing, & Exporting Databases
ds_msac2013_02_enus
Access 2013: Working with Databases
ds_msac2013_01_enus
Creating and Modifying Forms in Access 2013
mo_bgas_b04_dt_enus
Creating and Modifying Queries in Access 2013
mo_bgas_b03_dt_enus
Creating and Modifying Reports in Access 2013
mo_bgas_b05_dt_enus
Creating and Populating a Database in Access 2013
mo_bgas_b01_dt_enus
Modifying Tables in Access 2013
mo_bgas_b02_dt_enus
Access 2013 (Windows): Understanding Tables, Fields, & Entries
Lesson Objectives
Access 2013 (Windows): Understanding Tables, Fields, & Entries
- Understanding your database
- Creating a table
- Organizing your database items
- Inserting fields in your table
- Formatting your database fields
- Editing your database field properties
- Linking data in different tables
- Managing data relationships
- Visualizing object dependencies
Overview/Description
Before creating your database in Access 2013, it is a good idea to have an understanding of how it is structured. Learn about working with tables and fields, as well as formatting, editing, data relationships, and object dependencies.
Before creating your database in Access 2013, it is a good idea to have an understanding of how it is structured. Learn about working with tables and fields, as well as formatting, editing, data relationships, and object dependencies.
Target
Prerequisites: none
Access 2013: Creating Forms & Queries
Lesson Objectives
Access 2013: Creating Forms & Queries
- Creating a data entry form using the wizard
- Creating a data entry form from scratch
- Inserting text in a form
- Inserting data entry fields
- Inserting a list box
- Inserting check boxes
- Inserting buttons
- Reorganizing your form
- Adding information to your form
- Customizing the appearance of your form
- Editing your form's properties
- Creating a simple query
- Creating a crosstab query
- Performing a simple calculation
- Creating a calculated field
Overview/Description
In Access 2013, forms can simplify the process of data entry and queries allowing you to return information based on specified criteria. Learn about creating and customizing forms, as well as creating queries and calculations.
Target
Prerequisites: none
Access 2013: Finding & Organizing Data
Lesson Objectives
Access 2013: Finding & Organizing Data
- Sorting your data
- Filtering your data
- Locating a data value
- Replacing data values
- Editing your database indexes
- Finding duplicates in your database
Overview/Description
Adjust how you view and analyze your data by learning about the sorting and filtering features in Access 2013. Explore locating and replacing values, editing indexes, and finding duplicates.
Target
Prerequisites: none
Access 2013: Inserting, Importing, & Formatting Data
Lesson Objectives
Access 2013: Inserting, Importing, & Formatting Data
- Inserting data into your table
- Formatting your data
- Creating dropdown menus
- Creating data validation rules
- Using external data in your database
- Importing your address book from Outlook
- Creating labels
Overview/Description
After creating tables and fields, you're ready to add and format your data. Learn how to insert and format table data, create dropdown menus and validation rules, use external data, import address books, and create labels in Access 2013.
After creating tables and fields, you're ready to add and format your data. Learn how to insert and format table data, create dropdown menus and validation rules, use external data, import address books, and create labels in Access 2013.
Target
Prerequisites: none
Access 2013: Report & Analysis Tools
Lesson Objectives
Access 2013: Report & Analysis Tools
- Creating a quick report
- Creating your own database report
- Creating an automatic report
- Cleaning up your database
- Analyzing your database
Overview/Description
In Access 2013, a report can be used to present information that has been extracted from a database. Discover how to create a quick, database, and automatic reports. Also, explore methods of cleaning up and analyzing databases.
Target
Prerequisites: none
Access 2013: Saving, Printing, & Exporting Databases
Lesson Objectives
Access 2013: Saving, Printing, & Exporting Databases
- Saving your data
- Saving regularly
- Protecting your database
- Printing items in your database
- Exporting your database
- Sending your database table via email
Overview/Description
Data is key for any database application, and you'll want to be able to save, protect, and share it. Discover how to save data, protect your database, print database items, export a database, and send tables via email in Access 2013.
Target
Prerequisites: none
Access 2013: Working with Databases
Lesson Objectives
Access 2013: Working with Databases
- Creating a database
- Using database templates
- Understanding the interface
- Modifying the default navigation settings
- Customizing the interface
- Customizing your Quick Access Toolbar
- Customizing the ribbon
Overview/Description
Make the most of Access 2013 by learning the basics of database creation. Explore the interface; learn about default navigation settings; and discover how to customize the interface, Quick Access Toolbar, and ribbon.
Target
Prerequisites: none
Creating and Modifying Forms in Access 2013
Lesson Objectives
Creating and Modifying Forms in Access 2013
- create a form based on existing data in Access 2013
- decide how to create forms based on existing data in Access 2013
- design a form from scratch in Access 2013
- choose how to create forms from scratch in Access 2013
- create forms with application parts in Access 2013
- choose how to create forms with application parts in Access 2013
- format a form in Access 2013
- determine how to format forms in Access 2013
Overview/Description
Microsoft Office Access 2013 offers several options for creating and managing forms. You can link the forms to tables and queries by adding bound controls. You can also make a variety of changes to the look and feel of a form. This course describes how to create forms in Access 2013. It covers creating basic forms from scratch, from an existing table, or using the Form Wizard. It includes adding and setting form controls, as well as creating forms from application parts. Finally, this course will demonstrate ways to format a form.
Microsoft Office Access 2013 offers several options for creating and managing forms. You can link the forms to tables and queries by adding bound controls. You can also make a variety of changes to the look and feel of a form. This course describes how to create forms in Access 2013. It covers creating basic forms from scratch, from an existing table, or using the Form Wizard. It includes adding and setting form controls, as well as creating forms from application parts. Finally, this course will demonstrate ways to format a form.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Creating and Modifying Forms in Access 2013
Lesson Objectives
Creating and Modifying Forms in Access 2013
- create a form based on existing data in Access 2013
- decide how to create forms based on existing data in Access 2013
- design a form from scratch in Access 2013
- choose how to create forms from scratch in Access 2013
- create forms with application parts in Access 2013
- choose how to create forms with application parts in Access 2013
- format a form in Access 2013
- determine how to format forms in Access 2013
Overview/Description
Microsoft Office Access 2013 offers several options for creating and managing forms. You can link the forms to tables and queries by adding bound controls. You can also make a variety of changes to the look and feel of a form. This course describes how to create forms in Access 2013. It covers creating basic forms from scratch, from an existing table, or using the Form Wizard. It includes adding and setting form controls, as well as creating forms from application parts. Finally, this course will demonstrate ways to format a form.
Microsoft Office Access 2013 offers several options for creating and managing forms. You can link the forms to tables and queries by adding bound controls. You can also make a variety of changes to the look and feel of a form. This course describes how to create forms in Access 2013. It covers creating basic forms from scratch, from an existing table, or using the Form Wizard. It includes adding and setting form controls, as well as creating forms from application parts. Finally, this course will demonstrate ways to format a form.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Creating and Modifying Queries in Access 2013
Lesson Objectives
Creating and Modifying Queries in Access 2013
- filter data in Access 2013 with queries
- modify data in Access 2013 with queries
- create user-defined input queries in Access 2013
- decide how to create queries in Access 2013
- edit and save queries in Access 2013
- hide and delete query fields in Access 2013
- decide how to modify queries in Access 2013
- add calculated fields and grouping in Access 2013
- decide how to customize a query in Access 2013
Overview/Description
Microsoft Access 2013 includes a collection of query options to help make creating and modifying queries, easy. Access provides a number of query types with the ability to review data before running the queries. You can update or delete data that meets a certain criteria, request user input, and add calculated fields to queries. You can also group and summarize your data in queries. This course explores creating queries through the Query Wizard and Query Design. It also covers different types of queries like the Update and Delete queries, as well as the Parameter query. This course will cover adding new fields to queries, saving queries, and renaming them. It will also cover hiding or removing fields from queries as well as deleting queries. Finally, this course shows how to add calculated fields to queries, and group and summarize data in a query.
Microsoft Access 2013 includes a collection of query options to help make creating and modifying queries, easy. Access provides a number of query types with the ability to review data before running the queries. You can update or delete data that meets a certain criteria, request user input, and add calculated fields to queries. You can also group and summarize your data in queries. This course explores creating queries through the Query Wizard and Query Design. It also covers different types of queries like the Update and Delete queries, as well as the Parameter query. This course will cover adding new fields to queries, saving queries, and renaming them. It will also cover hiding or removing fields from queries as well as deleting queries. Finally, this course shows how to add calculated fields to queries, and group and summarize data in a query.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Creating and Modifying Queries in Access 2013
Lesson Objectives
Creating and Modifying Queries in Access 2013
- filter data in Access 2013 with queries
- modify data in Access 2013 with queries
- create user-defined input queries in Access 2013
- decide how to create queries in Access 2013
- edit and save queries in Access 2013
- hide and delete query fields in Access 2013
- decide how to modify queries in Access 2013
- add calculated fields and grouping in Access 2013
- decide how to customize a query in Access 2013
Overview/Description
Microsoft Access 2013 includes a collection of query options to help make creating and modifying queries, easy. Access provides a number of query types with the ability to review data before running the queries. You can update or delete data that meets a certain criteria, request user input, and add calculated fields to queries. You can also group and summarize your data in queries. This course explores creating queries through the Query Wizard and Query Design. It also covers different types of queries like the Update and Delete queries, as well as the Parameter query. This course will cover adding new fields to queries, saving queries, and renaming them. It will also cover hiding or removing fields from queries as well as deleting queries. Finally, this course shows how to add calculated fields to queries, and group and summarize data in a query.
Microsoft Access 2013 includes a collection of query options to help make creating and modifying queries, easy. Access provides a number of query types with the ability to review data before running the queries. You can update or delete data that meets a certain criteria, request user input, and add calculated fields to queries. You can also group and summarize your data in queries. This course explores creating queries through the Query Wizard and Query Design. It also covers different types of queries like the Update and Delete queries, as well as the Parameter query. This course will cover adding new fields to queries, saving queries, and renaming them. It will also cover hiding or removing fields from queries as well as deleting queries. Finally, this course shows how to add calculated fields to queries, and group and summarize data in a query.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Creating and Modifying Reports in Access 2013
Lesson Objectives
Creating and Modifying Reports in Access 2013
- create a report based on existing data in Access 2013
- decide how to create a report in Access 2013
- create a report from scratch in Access 2013
- determine how to create a report from scratch in Access 2013
- sort and group data in reports in Access 2013
- determine how to sort and group data in a report in Access 2013
- format a report in Access 2013
- prepare to print a report in Access 2013
- decide how to format and prepare to print a report in Access 2013
Overview/Description
Microsoft Access 2013 reports are used to convert data into useful information and are an essential part of any database application. It provides various methods of creating reports to present summarized information easily and effectively. This course demonstrates the use of the Report Wizard, Blank Report, and Report Design. Also covered is how to add and bind controls, group and sort data, and format and print reports.
Microsoft Access 2013 reports are used to convert data into useful information and are an essential part of any database application. It provides various methods of creating reports to present summarized information easily and effectively. This course demonstrates the use of the Report Wizard, Blank Report, and Report Design. Also covered is how to add and bind controls, group and sort data, and format and print reports.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Creating and Modifying Reports in Access 2013
Lesson Objectives
Creating and Modifying Reports in Access 2013
- create a report based on existing data in Access 2013
- decide how to create a report in Access 2013
- create a report from scratch in Access 2013
- determine how to create a report from scratch in Access 2013
- sort and group data in reports in Access 2013
- determine how to sort and group data in a report in Access 2013
- format a report in Access 2013
- prepare to print a report in Access 2013
- decide how to format and prepare to print a report in Access 2013
Overview/Description
Microsoft Access 2013 reports are used to convert data into useful information and are an essential part of any database application. It provides various methods of creating reports to present summarized information easily and effectively. This course demonstrates the use of the Report Wizard, Blank Report, and Report Design. Also covered is how to add and bind controls, group and sort data, and format and print reports.
Microsoft Access 2013 reports are used to convert data into useful information and are an essential part of any database application. It provides various methods of creating reports to present summarized information easily and effectively. This course demonstrates the use of the Report Wizard, Blank Report, and Report Design. Also covered is how to add and bind controls, group and sort data, and format and print reports.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Creating and Populating a Database in Access 2013
Lesson Objectives
Creating and Populating a Database in Access 2013
- create a desktop database in Access 2013
- create a table from scratch in Access 2013
- import data and link to data in Access 2013
- create a database template in Access 2013
- create relationships in a database in Access 2013
Overview/Description
Access 2013 is the newest version of Microsoft's dynamic database management system and it offers features that allow you to create and modify a variety of database types through a convenient graphic user interface. Access, as a desktop application, helps you store and manage related information in one place. It helps prevent errors, inconsistencies, and duplicate information. This course explores the fundamentals of databases and the many tools that will help you create and modify databases in Access 2013. It will cover creating and saving databases, creating and renaming tables, importing and linking data, as well as creating relationships between tables.
Access 2013 is the newest version of Microsoft's dynamic database management system and it offers features that allow you to create and modify a variety of database types through a convenient graphic user interface. Access, as a desktop application, helps you store and manage related information in one place. It helps prevent errors, inconsistencies, and duplicate information. This course explores the fundamentals of databases and the many tools that will help you create and modify databases in Access 2013. It will cover creating and saving databases, creating and renaming tables, importing and linking data, as well as creating relationships between tables.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Creating and Populating a Database in Access 2013
Lesson Objectives
Creating and Populating a Database in Access 2013
- create a desktop database in Access 2013
- create a table from scratch in Access 2013
- import data and link to data in Access 2013
- create a database template in Access 2013
- create relationships in a database in Access 2013
Overview/Description
Access 2013 is the newest version of Microsoft's dynamic database management system and it offers features that allow you to create and modify a variety of database types through a convenient graphic user interface. Access, as a desktop application, helps you store and manage related information in one place. It helps prevent errors, inconsistencies, and duplicate information. This course explores the fundamentals of databases and the many tools that will help you create and modify databases in Access 2013. It will cover creating and saving databases, creating and renaming tables, importing and linking data, as well as creating relationships between tables.
Access 2013 is the newest version of Microsoft's dynamic database management system and it offers features that allow you to create and modify a variety of database types through a convenient graphic user interface. Access, as a desktop application, helps you store and manage related information in one place. It helps prevent errors, inconsistencies, and duplicate information. This course explores the fundamentals of databases and the many tools that will help you create and modify databases in Access 2013. It will cover creating and saving databases, creating and renaming tables, importing and linking data, as well as creating relationships between tables.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Modifying Tables in Access 2013
Lesson Objectives
Modifying Tables in Access 2013
- create and modify fields in Access 2013
- control how data may be entered into a database in Access 2013
- decide how to create fields and control data entry in Access 2013
- add and modify records in Access 2013
- sort and filter records in Access 2013
- manage records in Access 2013
- format a table in Access 2013
- decide how to format a table in Access 2013
Overview/Description
Microsoft Office Access 2013 makes it easy for you to modify database tables. It allows you to customize the table fields, and control and restrict data entry. You can modify the records and sort and filter them. And, you can also customize the visual appeal by formatting the table. This course explores ways to modify tables. It will cover creating and modifying fields, controlling data entry with required fields, indexing, input masks, and data validation rules. The course will also cover ways manage records including adding, updating, deleting records, as well as sorting and filtering. Finally, it will cover ways to format a table.
Microsoft Office Access 2013 makes it easy for you to modify database tables. It allows you to customize the table fields, and control and restrict data entry. You can modify the records and sort and filter them. And, you can also customize the visual appeal by formatting the table. This course explores ways to modify tables. It will cover creating and modifying fields, controlling data entry with required fields, indexing, input masks, and data validation rules. The course will also cover ways manage records including adding, updating, deleting records, as well as sorting and filtering. Finally, it will cover ways to format a table.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Modifying Tables in Access 2013
Lesson Objectives
Modifying Tables in Access 2013
- create and modify fields in Access 2013
- control how data may be entered into a database in Access 2013
- decide how to create fields and control data entry in Access 2013
- add and modify records in Access 2013
- sort and filter records in Access 2013
- manage records in Access 2013
- format a table in Access 2013
- decide how to format a table in Access 2013
Overview/Description
Microsoft Office Access 2013 makes it easy for you to modify database tables. It allows you to customize the table fields, and control and restrict data entry. You can modify the records and sort and filter them. And, you can also customize the visual appeal by formatting the table. This course explores ways to modify tables. It will cover creating and modifying fields, controlling data entry with required fields, indexing, input masks, and data validation rules. The course will also cover ways manage records including adding, updating, deleting records, as well as sorting and filtering. Finally, it will cover ways to format a table.
Microsoft Office Access 2013 makes it easy for you to modify database tables. It allows you to customize the table fields, and control and restrict data entry. You can modify the records and sort and filter them. And, you can also customize the visual appeal by formatting the table. This course explores ways to modify tables. It will cover creating and modifying fields, controlling data entry with required fields, indexing, input masks, and data validation rules. The course will also cover ways manage records including adding, updating, deleting records, as well as sorting and filtering. Finally, it will cover ways to format a table.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013
